Airline Satisfaction: What Makes a Good Flight?

Airplanes are one of the most common modes of transportation, and many have different opinions as to what makes a good flight. Some might focus on the snacks, others might love the leg room, and others might be satisfied by a simple low price. We sought to examine the root of what defines a satisfying or unsatisfying flight, using demographic data and traveler-submitted ratings on various aspects of the flight experience to find this root of satisfaction.

Taking a broad look at all the data, we had over 100,000 customers surveyed, which gave us a lot of stability in the data but also required us to sift through what was actually important to us. We decided to focus on the column titled, "satisfaction" as our overall comparison measure, seeing if we could identify the principal factor driving the travelers to respond in a certain way. Our first visualization describes the raw percentage of travelers satisfied vs. those neutral or dissatisfied, allowing for our first insight: a small majority of travelers are neutral or dissatisfied with their flights.

We will explore the connection between satisfaction and travel time, gender/age, and service ratings as well as our overall conclusions in the following sections.

Satisfaction by Travel Time

Our first broad category of variables relates to travel time, seeing if factors such as the duration of the flight and any arrival and departure delays connected to the flight affect customer satisfaction.

Visualization: Satisfaction by Flight Time

Visualization: Satisfaction by Arrival and Departure Delays

Insert here

Conclusions/Insights: Satisfaction by Travel Time

In looking at this category, we first constructed a flight time boxplot. Interestingly longer flight distances tend to make customers more satisfied. This may be because airlines may tend to over focus their service and resources on longer flights. This chart may suggest to airlines that they should spend more on shorter flights given there is less satisfaction there. Perhaps, they could provide some quality features they do on longer flights on shorter flights such as a premium first class with a bed.

We also made a scatter plot highlighting the correlation between delays in minutes and satisfaction. As you can see, as the delays increase there is a greater percentage of neutral or dissatisfied customers. Sadly, given the amount of data we have it is difficult to tell the trends in the bottom left of the graph, but it looks like the majority of those in the bottom left are satisfied with their flight experience. Therefore, if airlines want to increase customer satisfaction they should work on the timeliness of their flights.

Satisfaction by Gender/Age

Our second broad category of variables relates to gender and age, seeing if the gender of the flyer or their age has a broad affect on customer satisfaction.

Visualization: Satisfaction by Gender

Visualization: Satisfaction by Age

Conclusions/Insights: Satisfaction by Gender/Age

These two visualizations reflect the impact of gender and age on overall satisfaction, starting with a pie chart. Here it can be seen that more males and females were dissatisfied than satisfied. Prior to looking at this graph it could have been told where airlines should focus their efforts on improving the flight experience, but there is a insignificant difference in each gender category. However, 1,500 more females were dissatisfied than males despite having an extremely similar satisfied number. Using this airlines might want to focus on improving females experience even though the difference is very small. Airlines could include makeup wipes in their care poackages or rom coms and soap operas in their in flight entertainment.

Moving to the histogram, interestingly the younger and older ages are generally very dissatisfied with their flight experience. Airlines already take this into account with allowing those with very young children and the elderly board early. However, they may want to take other precautions. They could incorporate more kids shows into in-flight entertainment and could maybe provide the elderly with newspapers and other things. They could also give the elderly free upgrades if seats are available to allow them more room as their bodies do not function as well.

Satisfaction by Service Ratings

Our last broad category of variables relates to ratings associated with the flight experience, seeing how much they affect customer satisfaction as a whole and which in particular might have the greatest impact.

Visualization: Satisfaction by Flight Timeliness

Insert here

Visualization: Satisfaction by Time Convenient Rating

Conclusions/Insights: Satisfaction by Service Ratings

We utilized two visualizations to address the effect of service ratings on overall flyer satisfaction. (INSERT 5 desc)

Our second visualization, the funnel graph, shows that most customers do rate their travel experience to be time convenient with the more customers rating their time convenience from ratings 4 - 5 rather than 1 - 2. Given more customers were dissatisfied than satisfied with their travel experience this seems to be odd. This may lead one to think that time factors are not a major role in passenger satisfaction, leading us to consider examining the impact of other service ratings and see if any tie more strongly to passenger satisfaction than time convenience does.

Overall Conclusions

Last thoughts